CREATE VIEW [dbo].[vw_EShopGoods]
AS
SELECT        good.Id, good.K_Code AS Code, good.Barcode, good.Name1 AS Name, good.Name2 AS Alias, g.Id AS GroupId, good.Eshop_Flag AS isActive, u1.Id AS UnitId, good.SalesCeiling, good.MinQtyTelegram, u2.Id AS unit2Id, 
                         good.R_Unit1_2, good.Duty_Flag, good.TaxPercent AS TaxationPercent
FROM            dbo.KalaId AS good INNER JOIN
                         dbo.Unit1 AS u1 ON good.U_Code1 = u1.U_Code1 LEFT OUTER JOIN
                         dbo.Unit2 AS u2 ON good.U_Code2 = u2.U_Code2 LEFT OUTER JOIN
                         dbo.Group1 AS g ON g.Gid = good.Gid_Fk